package be.artesis.titamo.io.dbinterface;

public final class MySQLInterface implements SQLInterface
{
	
	public String getPKExtraOps() {
		return "NOT NULL AUTO_INCREMENT";
	}

	public String getPKType() {
		return "int(10)";
	}

	public String getPKStatement() {
		return "PRIMARY KEY";
	}

	public String getStringType() {
		return "varchar";
	}

	public String getExtraCreationOptions() {
		return "ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1";
	}

	public String getDropTableQuery() {
		return "DROP TABLE IF EXISTS";
	}
	
	public String getAlterTableQuery()
	{
		return "ALTER TABLE";
	}

	public String getResetIndexQuery() {
		return "AUTO_INCREMENT=1";
	}

	public String getEmptyTableQuery() {
		return "DELETE FROM";
	}

	public String getEmptyTableOps() {
		return "";
	}

	public String escapeChar(String character) {
		return character + character;
	}

	public String getCaseInsensitiveLike() {
		return "LIKE";
	}

	public String getCharType() {
		return "char";
	}

	public String getTinyTextType() {
		return "TINYTEXT";
	}
	
	public String getIntType(int max_size)
	{
		return "int("+max_size+")";
	}

}
